<?xml version="1.0" encoding="utf-8" ?> 
<?evaluant-application progid="EUSS.Mapping"?>
<Mapping xmlns="http://euss.evaluant.com/schemas/MappingSchema.xsd">
	
	<Entity type="Northwind:Order" table="Orders">	
		<Id field="OrderID" >
			<Generator name="native" >
				<Property name="dbType">Int32</Property>
				<Property name="size">4</Property>
			</Generator>
		</Id>
		<Attribute	name="OrderDate" field="OrderDate" db-type="DateTime"/>
		<Attribute	name="ShipName" field="ShipName" db-type="AnsiString" size="40" />
		<Attribute  name="ShipVia" field="ShipVia" db-type="Int32"/>
	</Entity>
	 
	<Entity type="Northwind:Customer" table="Customers">
		<Id field="CustomerID" >
			<Generator name="assigned" >
				<Property name="dbType">StringFixedLength</Property>
				<Property name="size">5</Property>
			</Generator>
		</Id>
		<Attribute	name="CompanyName" field="CompanyName" default-value="Notgiven" db-type="AnsiString" size="40" not-null="true"/>
		<Attribute	name="ContactName" field="ContactName" db-type="AnsiString" size="30" />
		<Attribute  name="City" field="City" db-type="AnsiString" size="15" />	
						
		<Reference name="Orders" entityChild="Northwind:Order" >
      <Rule parentField="CustomerID"  childTable="Orders"  childField="CustomerID" />
		</Reference>
	</Entity>
</Mapping>
 